USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[DeleteAllLogData]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.DeleteAllLogData
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Deletes all logged table data
-- =============================================
CREATE PROCEDURE DeleteAllLogData


AS
BEGIN

	DELETE FROM Assists
	DELETE FROM CaptureBlocks
	DELETE FROM CaptureList
	DELETE FROM Captures
	DELETE FROM ChatLog
	DELETE FROM Destructions
	DELETE FROM Dominations
	DELETE FROM Engineering
	DELETE FROM Flag
	DELETE FROM Kills
	DELETE FROM LogFiles
	DELETE FROM Matches
	DELETE FROM MatchPlayerList
	DELETE FROM MedicCharge
	DELETE FROM PlayerNameList
	DELETE FROM Players
	DELETE FROM Revenges
	DELETE FROM Rounds
	DELETE FROM Suicides


END
GO
